Welcome to the capstone course. You're now within reaching distance of the
end of your database engineering journey. In this final course you need to prove
your new skills by helping Little Lemon complete a series of
database related tasks. These tasks include setting up a database
in MySQL workbench using a MySQL instance server, creating an entity
relationship or Diagram and implementing it in MySQL workbench. And you need to commit
the project using Git. You also need to help them create sales
reports from the data in their database, build a table booking system, generate
data insights using data analytics, and create a database client. Let's take a few minutes
to review the processes and tools that you'll use to
complete these exercises. In the first set of tasks, you'll help
Little Lemon to build a relational database system by designing
a well structured entity model or Diagram that conforms to the three
fundamental normal forms. You'll design the Diagram
using MySQL workbench, a unified visual tool used for
database modeling and management. A key feature of MySQL workbench that
you'll make use of is the ability to transform your data model in a physical
database schema in a MySQL server. Once you've created
the Little Lemon database, you'll then commit your project using Git,
the version control system. You'll also make use of GitHub
to store your Git repositories. Your next task is then to create sales
reports from the data in the Little Lemon database. You'll create these sales reports using
database queries, procedures, and prepared statements. Let's look at these in more detail. You'll use virtual tables to make use
of data that exists in other tables and simplify data access and queries. You'll also make use of different kinds
of JOIN clauses to link records of data between one or
more tables based on a common column. You'll help Little Lemon to use
stored procedures to create reusable code that can be invoked and
executed as required. And you'll also rely on prepared
statements that can be used repeatedly without the need for compiling or
using valuable MySQL resources. Another task you assisted Lemon with is
building a table booking system in their databas, that they can use to keep track
of guests visiting the restaurant. This task mainly consists of using
SQL queries and transactions. Let's review some examples of the SQL
queries and transactions that you'll use. You'll create data using
standard insert into statements. You'll change data in the database
using update statements. You'll also delete or
drop data using delete statements, and finally you'll read your data using
read queries like select statements. You'll also make use of triggers to store
a set of actions in the form of a stored program, that you can then invoke
automatically when certain events occur. Once you're confident that
your code is correct, you'll commit your progress to Git. In the next task, you'll help Little Lemon use their
data to generate business insights. You'll carry out this task using tableau,
the data visualization tool. Let's review the process steps that
you'll follow to complete this task. You'll first connect your
data sources to tableau. You'll then prepare your data for analysis
and focus on the most relevant data. The next step is to create a visualization
of your data using its UI elements. Finally, you'll use tableau to produce
interactive real time data visualizations in the form of dashboards. These process steps will
help to provide clear and relevant answers to Little Lemons
important business questions. Your final task is to help
Little Lemon create a database client, so that they can interact with their
database using a python based application. To begin, you'll first need to identify
which version of python is running on your machine. Once you've confirmed that you're running
the most recent iteration of python, you'll need to install
the Jupyter IDE to run your code on. You can then open a new instance
of the Jupyter notebook, and use it to connect python to
the Little Lemon MySQL database. You can establish this connection using
the python library, MySQL connector and the pip software package. Once you've set up your python environment
you can begin working with your database client. So now that you're familiar with
the tasks you need to complete, it's time to get started. Don't worry, I'll be here to provide
you with guidance along the way. You can also refer to
the relevant learning material from previous courses
if you need more help. Best of luck.